Re: pg_dumpall fails - Mailing list pgsql-admin

From Willy Wonka
Subject Re: pg_dumpall fails
Date
Msg-id p05111709b9bb94b67fd5@[192.168.1.129]
Whole thread Raw
In response to Re: pg_dumpall fails  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
i'm getting further, i think.

i dropped and created the new sequence.  i don't think i had to set
the current value, because currval returned
submissions_submission_id_seq.currval is not yet defined in this
session [this database isn't on a production server at the moment]

now i get a new error:

>  pg_dumpall > bigdump
dumpSequence(website_suggest_id_seq): 0 (!= 1) tuples returned by SELECT
pg_dump failed on immedia2002, exiting

ok, so 0 isn't 1.  is there anything i can do about this one?

-c

At 11:38 PM -0400 9/27/02, Tom Lane wrote:
>Willy Wonka <lunchtime@onethirty.org> writes:
>>  i don't know what my brother has been doing on the other end, but
>>  pg_dumpall now returns this:
>
>  > SELECT nextval ('"art_links_id_seq"');
>  > dumpSequence(submissions_submission_id_seq): different sequence name
>>  returned by SELECT: submissions_n_submission_id_seq
>
>What he's been doing is renaming sequences ... pg_dump doesn't like
>that, for no particularly good reason :-(.  (This gratuitous failure
>is gone in 7.3, but that doesn't help you much today.)  I'd suggest
>dropping and recreating the sequence, then using setval() to set its
>current value correctly.  Then you should be able to pg_dump.
>
>            regards, tom lane



pgsql-admin by date:

Previous
From: Derek Neighbors
Date:
Subject: pg_dumpall / restore issues
Next
From: "cameron.hanover"
Date:
Subject: old db in a new system